DigitalOcean install reference
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-14-04
assuming you have ubuntu already installed via virtualbox or direct install on pc:
first, always do this on new ubuntu installs:
$ sudo apt-get update
$ sudo apt-get upgrade1. Install apache server
$ sudo apt-get install apache2If installing on DigitalOcean, go to the ip address of the machine and check that you see the Apache2 Ubuntu Default page.
2. Install MySQL
if necessary, also see:
How to Upgrade MySQL from 5.5 to 5.7
$ sudo apt-get update$ sudo wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb
$ sudo wget http://dev.mysql.com/get/mysql-apt-config_0.7.3-1_all.deb
$ sudo dpkg -i mysql-apt-config_0.7.3-1_all.debYou'll see a prompt that asks you which MySQL product you want to configure. The MySQL Server option, which is highlighted, should say mysql-5.7. If it doesn't, press ENTER, then scroll down to mysql-5.7 using the arrow keys, and press ENTER again.
Once the option says mysql-5.7, scroll down on the main menu to Apply and press ENTER again. Now, update your package index.
NOTE: I have had problems where the prompts would not let me proceed with the installation when I selected mysql 5.7. One solution is that when you select ‘OK' on the first screen to exit and you return to the command line, just continue with the code below. This will install 5.7.
Then:
$ sudo apt-get update
$ sudo apt-get install mysql-server php5-mysql
You'll be prompted to create a root password during the installation. Choose a secure one and make sure you remember it, because you'll need it later.
To check the mysql version:
$ mysql --versionThen:
$ sudo mysql_secure_installation
You will be prompted to enter to password for the user root that you just created. Then follow the prompts.
Prerequisites: https://www.digitalocean.com/community/tutorials/initial-server-setup-with-ubuntu-14
Testing MySQL:
$ sudo service mysql statusYou'll see the following output:
* MySQL Community Server 5.7.16 is runningIf MySQL isn't running, you can start it with:
$ sudo service mysql startFor an additional check, you can try connecting to the database using the mysqladmin tool, which is a client that lets you run administrative commands. For example, this command says to connect to MySQL as root (-u root), prompt for a password (-p), and return the version.
mysqladmin -p -u root versionYou should see output similar to this:
mysqladmin Ver 8.42 Distrib 5.7.16, for Linux on x86_64
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 5.7.16
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 13 min 34 sec
Threads: 1 Questions: 15 Slow queries: 0 Opens: 123 Flush tables: 1 Open tables: 42 Queries per second avg: 0.018Additional options to tune MySQL or just skip to Step 3.
MySQL Tuner is a Perl script that connects to a running instance of MySQL and provides configuration recommendations based on workload. Ideally, the MySQL instance should have been operating for at least 24 hours before running the tuner. The longer the instance has been running, the better advice MySQL Tuner will give.
Install MySQL Tuner from Ubuntu’s repositories:
$ sudo apt-get install mysqltunerTo run it:
$ sudo mysqltunerYou will be asked for the MySQL root user’s name and password. The output will show two areas of interest: General recommendations and Variables to adjust.
MySQL Tuner is an excellent starting point to optimize a MySQL server, but it would be prudent to perform additional research for configurations tailored to the application(s) utilizing MySQL on your Linode.
Securely Administer MySQL with an SSH Tunnel
https://www.linode.com/docs/databases/mysql/securely-administer-mysql-with-an-ssh-tunnel
also see:
MySQL vs MariaDB
3. Install PHP
$ sudo apt-get install php5 libapache2-mod-php5 php5-mcryptUPDATE: To install Latest PHP
$ sudo add-apt-repository ppa:ondrej/php
$ sudo apt-get update
$ sudo apt-get install php7.2-cliTo make the web server to prefer PHP files over .html files:
sudo nano /etc/apache2/mods-enabled/dir.confadd the PHP index file to the first position:
<IfModule mod_dir.c>
DirectoryIndex index.php index.html index.cgi index.pl index.xhtml inde$
</IfModule>Ctrl+x to save, ‘Y' to exit.
restart the Apache web server:
sudo service apache2 restartto install optional PHP components, see this:
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-14-04
to test PHP install:
sudo nano /var/www/html/info.phpenter the lines below:
<?php
phpinfo();
?>Ctrl+x to save, ‘Y' to exit.
4. Install phpMyAdmin:
sudo apt-get install phpmyadminIMPORTANT: When the first prompt appearch, apache2 is highlighted, but not selected. Hit “SPACE”, “TAB”, and then “ENTER” to select Apache.
Select ‘YES' on next prompt to configure database for phpmyadmin with dbconfig-common
Enter a password for the database's adminstrative user.
Then provide a password for phpmyadmin to register with the database server, and confirm.
Next, enable php5-mcrypt extention:
sudo php5enmod mcryptthen restart the server:
sudo service apache2 restartyou can now access phpMyAdmin at
http://domain_name_or_IP/phpmyadmin
5. Installing an SSH server
sudo apt-get install openssh-serverThis service will start running as soon as it is installed. To verify this, you can do:
ssh localhostAlso, to access web server and ssh on virtualbox, you must go into ‘Settings' > ‘Network' > click on ‘Advanced' arrow > click ‘Port Forwarding' . click the green ‘+' icon on the right hand side > then:
make sure to put in Host IP (example: 192.168.1.x) and Host Port (example: 80 or something else…) and Guest IP (example 10.0.2.15 or you can find it using ifconfig at terminal) and Guest Port (example: 80 or something else). For SSH, do the same except Host Port and Guest Port are both 22.